Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RecipeID (FK)(PK) | A system assigned unique identifier for the recipe | ID_RCPE | Identity | integer | Recipe(ST_RCP) |
ComponentID (FK)(PK) | A unique system assigned identifier for the RawMaterialComponent that goes into the Recipe | ID_COM | Identity | integer | RawMaterialComponent(CO_COM_RAW_MTR) |
ServingsCount | The number of servings of a component that make up the Ingredient. | QU_CNT_SRV | QuantityShortCount | decimal(3,0) | |
CostInclusiveFlag | A flag denoting if the cost of the ingredient is (or is not) included in the cost of the completed PreparedItem | FL_CST_INC | Flag | integer | |
WasteFlag | A flag denoting if the recipe ingredient is wasted when the PreparedItem is discarded. e.g. When a piece of cake is discarded the whipped cream & spoon that are included with the cake when it is sold, are not discarded | FL_WST | Flag | integer | |
KeyIngredientFlag | A flag denoting that the ingredient is required to make up the PreparedItem. e.g. Patties are key ingredients in a burger, but pickles are not. | FL_IGDT_KY | Flag | integer | |